Optional SQL Script Updates

This section describes how to optionally update SQL scripts.

➢ Do the following:
1. Connect to the SQL Server using the following credentials.

A picture containing text Description automatically generated

Parameter

Description

Server type

Database Engine

Server name

[servername]\SQLSYSADMIN

Authentication

Windows Authentication

Graphical user interface, text, application, email Description automatically generated

2. Open the SqlScript\Upgrade directory.

Graphical user interface, text, application Description automatically generated

3. In the Windows Explorer, select 10.Add-columns.sql and drag and release it into the grey area in the SQL Manager Studio.

Graphical user interface, text Description automatically generated

4. Make sure SysAdminTenant database is selected and then press Execute.
5. Repeat the above steps for “20.RefreshSpf.sql”.
6. In addition, when UMP-SP is deployed with OVOC, set the OvocEnabled parameter to true in the dbo.ApplicationSetting in the SysAdminTenant database.